﻿CREATE TABLE [dbo].[tblTransaction] (
    [TransactionID]         INT           IDENTITY (1, 1) NOT NULL,
    [TransactionTypeCode]   CHAR (1)      NOT NULL,
    [Amount]                MONEY         NOT NULL,
	[CreateDate]	smalldatetime not null,
    [ResponseDate]          SMALLDATETIME NULL,
    [TransactionStatusCode] CHAR (1)      NOT NULL,
    [BankCheckNumber]       INT           NULL,
    [RelatedTransactionID]  INT           NULL,
    [TransactionResponseID] INT           NULL,
    [AVSResponse]           CHAR (2)      NULL,
    [CVV2Response]          CHAR (1)      NULL,
	[OrderID]	int	null,
	[PackageID]	int null,
	[RetryCount] int null
);

